package cn.imvc.app.repositories;

import java.util.Date;
import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;

import cn.imvc.app.entities.Orders;
import cn.imvc.app.entities.StorageOrder;
import cn.imvc.data.jpa.repository.IJpqlExecutor;
import cn.imvc.data.jpa.repository.ISqlExecutor;

public interface StorageOrderRepository extends JpaRepository<StorageOrder, Integer>,IJpqlExecutor<StorageOrder>,ISqlExecutor<StorageOrder>{
	public List<StorageOrder> findByStateAndOrder(byte state,Orders orders);

	public List<StorageOrder> findByState(Byte value);

	public List<StorageOrder> findByOrder(Orders order);
	
	public List<StorageOrder> findByCode(String code);

	public List<StorageOrder> findByStateAndReceiptEndTimeLessThan(Byte value, Date date);
}
